--------------------------------------------------------
--  DDL for Table T_API_QD_PROCESS
--------------------------------------------------------

  CREATE TABLE T_API_QD_PROCESS
   (	"ID" NUMBER(10,0), 
	"EFFEC_DATE" DATE DEFAULT '1900-01-01', 
	"TO_EFFEC_DATE" DATE DEFAULT '3000-01-01', 
	"LAST_UPDATED_USER_ID" NUMBER(10,0) DEFAULT '0', 
	"LAST_UPDATED_REG_DATE" DATE DEFAULT sysdate, 
	"NAME" VARCHAR2(255 BYTE)
   )  ;

--------------------------------------------------------
--  DDL for Table T_API_QD_PROCESS_STEP
--------------------------------------------------------

  CREATE TABLE T_API_QD_PROCESS_STEP
   (	"PROCESS_ID" NUMBER(10,0), 
	"ID" NUMBER(10,0), 
	"EFFEC_DATE" DATE DEFAULT '1900-01-01', 
	"TO_EFFEC_DATE" DATE DEFAULT '3000-01-01', 
	"LAST_UPDATED_USER_ID" NUMBER(10,0) DEFAULT '0', 
	"LAST_UPDATED_REG_DATE" DATE DEFAULT sysdate, 
	"NAME" VARCHAR2(255 BYTE), 
	"TYPE" NUMBER(10,0) DEFAULT 0, 
	"QUERY_NAME" VARCHAR2(1000 BYTE), 
	"STEP_MODE" VARCHAR2(10 BYTE)
   )  ;
   
   --------------------------------------------------------
--  DDL for Table T_API_QD_PROCESS_STEP_PARAMS
--------------------------------------------------------

  CREATE TABLE T_API_QD_PROCESS_STEP_PARAMS
   (	"PROCESS_ID" NUMBER(10,0), 
	"STEP_ID" NUMBER(10,0), 
	"ID" NUMBER(10,0), 
	"EFFEC_DATE" DATE DEFAULT '1900-01-01', 
	"TO_EFFEC_DATE" DATE DEFAULT '3000-01-01', 
	"LAST_UPDATED_USER_ID" NUMBER(10,0) DEFAULT '0', 
	"LAST_UPDATED_REG_DATE" DATE DEFAULT sysdate, 
	"PARAMS_TYPE" VARCHAR2(1 BYTE) DEFAULT '-', 
	"NAME" VARCHAR2(255 BYTE), 
	"PARAM_VALUE" VARCHAR2(1000 BYTE), 
	"DEFAULT_VALUE" VARCHAR2(1000 BYTE)
   ) 
   ;

